/**
 * 
 */
package com.cqcis.uip.module.salary.oper.dao;

import java.util.List;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.cqcis.uip.base.framework.utils.JdbcUtil;
import com.cqcis.uip.module.salary.oper.domain.Employe;

/**
 * @author 李世军
 *
 * 创建于 2012-3-7 下午01:31:34
 */
public class EmployeDao extends JdbcDaoSupport {
	private static String FIELDS = " id ,name ,gender ,age ,employed_data ,positive_data ,identity_card ,registered_residence ,birthday ,phone ,email ,qq ,education ,profession ,graduate_school ,work_experience ,state ,company_id ,department_id ,office_id ,salary_grade ,position_level ";
	private static String SELECT_SQL = " select "+FIELDS+" from employecontrol_employe where state=? ";
	
	/**
	 * 查询所有员工
	 * @param state(1:入职-试用期间,2:转正,3:离职,4:全职,5:兼职) 
	 * @return
	 */
    public List<Employe> query(String state) {
    	return JdbcUtil.queryForList(this, Employe.class, SELECT_SQL, state);
    }
}
